<?php

/**
 *      [Discuz!] (C)2001-2099 Comsenz Inc.
 *      This is NOT a freeware, use is subject to license terms
 *
 *      $Id: install.php 34517 2014-05-14 06:14:41Z nemohou $
 */

if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}

$sql = <<<EOF
DROP TABLE IF EXISTS cdb_common_news;
CREATE TABLE cdb_common_news(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `talk_date` varchar(100) NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `new` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='年会活动留言' AUTO_INCREMENT=0 ;

DROP TABLE IF EXISTS cdb_common_phone;
CREATE TABLE cdb_common_phone(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `phone` varchar(50) NOT NULL COMMENT '电话号码',
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='年会活动号码' AUTO_INCREMENT=0 ;


EOF;

runquery($sql);

$finish = TRUE;

?>